[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '9' >
6 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39 | 12.45 | 2001-06-23 | Production | simon0@adventure-works.com | Simon Rapier | 963-555-0134 | 276751903 | Simon | M | 2020-01-15 | Rapier | adventure-works\simon0 | S | D | 9 | 1 | 963-555-0134 | | 39 | 2020-01-15 | Current | Production Technician - WC60 | 38 |
| 160 | 12.45 | 1987-03-19 | Production | eugene1@adventure-works.com | Eugene Kogan | 173-555-0179 | 66073987 | Eugene | M | 2020-03-17 | Kogan | adventure-works\eugene1 | S | O | 9 | 1 | 173-555-0179 | | 38 | 2020-03-17 | Current | Production Technician - WC60 | 36 |
| 198 | 12.45 | 1997-02-16 | Production | thomas0@adventure-works.com | Thomas Michaels | 278-555-0118 | 500412746 | Thomas | M | 2020-04-04 | Michaels | adventure-works\thomas0 | M | R | 9 | 1 | 278-555-0118 | | 38 | 2020-04-04 | Current | Production Technician - WC60 | 37 |
| 78 | 12.45 | 1995-09-01 | Production | james0@adventure-works.com | James Kramer | 119-555-0117 | 339712426 | James | M | 2020-02-03 | Kramer | adventure-works\james0 | M | D | 9 | 1 | 119-555-0117 | | 39 | 2020-02-03 | Current | Production Technician - WC60 | 39 |
| 86 | 12.45 | 1999-12-27 | Production | nancy0@adventure-works.com | Nancy Anderson | 970-555-0118 | 693325305 | Nancy | F | 2020-02-09 | Anderson | adventure-works\nancy0 | M | A | 9 | 1 | 970-555-0118 | | 37 | 2020-02-09 | Current | Production Technician - WC60 | 34 |
| 125 | 12.45 | 1984-10-03 | Production | bryan0@adventure-works.com | Bryan Baker | 712-555-0113 | 458159238 | Bryan | M | 2020-02-28 | Baker | adventure-works\bryan0 | S | 9 | 1 | 712-555-0113 | | 37 | 2020-02-28 | Current | Production Technician - WC60 | 35 |
Generated 2025-08-06 23:14:13.821 UTC